package com.ruoyi.waterPrice.mapper;

import com.ruoyi.common.core.domain.base.datam.MiMainchanB;
import com.ruoyi.common.core.domain.business.waterDistribution.MiFarmlandB;
import com.ruoyi.common.core.domain.business.waterPrice.WiFarmacctY;

import java.util.List;

/**
 * 农户水费台账登记Mapper接口
 * 
 * @author ps
 * @date 2023-02-17
 */
public interface WiFarmacctYMapper 
{
    /**
     * 查询农户水费台账登记
     * 
     * @param feeYr 农户水费台账登记主键
     * @return 农户水费台账登记
     */
    public WiFarmacctY selectWiFarmacctYByFeeYrAndFarmCd(String feeYr,String farmCd);

    /**
     * 查询农户水费台账登记列表
     * 
     * @param wiFarmacctY 农户水费台账登记
     * @return 农户水费台账登记集合
     */
    public List<WiFarmacctY> selectWiFarmacctYList(WiFarmacctY wiFarmacctY);

    /**
     * 新增农户水费台账登记
     * 
     * @param wiFarmacctY 农户水费台账登记
     * @return 结果
     */
    public int insertWiFarmacctY(WiFarmacctY wiFarmacctY);

    /**
     * 修改农户水费台账登记
     * 
     * @param wiFarmacctY 农户水费台账登记
     * @return 结果
     */
    public int updateWiFarmacctY(WiFarmacctY wiFarmacctY);

    /**
     * 删除农户水费台账登记
     * 
     * @param feeYr 农户水费台账登记主键
     * @return 结果
     */
    public int deleteWiFarmacctYByFeeYr(String feeYr);

    /**
     * 批量删除农户水费台账登记
     * 
     * @param feeYrs 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteWiFarmacctYByFeeYrs(String[] feeYrs);

    /**
     * 获取农户名称
     * @param farmCd
     * @return
     */
    String getFarmNm(String farmCd);

    /**
     * 获取机构下农户台账
     * @param feeYr
     * @param orgCd
     * @return
     */
    List<WiFarmacctY> selectWiFarmacctYListByOrgCdAndYr(String feeYr, String orgCd);

    /**
     * 获取操作人名称
     * @param operId
     * @return
     */
    String getOperNm(String operId);

    /**
     * 农户当年收缴分析
     * @param year
     * @param orgCdQuery
     * @return
     */
    List<WiFarmacctY> getFarmFeeIncomeAnalys(String year, String orgCdQuery);

    /**
     * 查询水管员管辖渠系
     * @param mainCd
     */
    List<MiMainchanB> selectChanCds(String mainCd);

    String getChanNm(String chanCd);

    WiFarmacctY getFeeInfoByChanCd(String chanCdQuery);

    List<WiFarmacctY> getFarmCdsByChanCd(String chanCdQuery);
}
